package week08;

public class Work2 {

    public static void main(String[] args) {

        String[] sqlArray = new String[]{
                "create table test1(a1 int, a2 int) using parquet",
                "create table test2(b1 int, b2 int) using parquet",

                "select ad1, (a2 + 1) as ad2 from ("
                        + " select (a1 + 1) as ad1, a2 from test1 where a1 > 10"
                        + ") where ad1 > 1 and 1=1 ",
                "select distinct a1, a2, 'custom' as a3  from ("
                        + " select * from test1 where a2 = 10 and 1 = 1"
                        +") where a1 > 5 and 1 = 1 "
                        + "except select b1, b2, 1.0 as b3 from test2 where b2 = 10 "
        };





    }
}
